CREATE TABLE [dbo].[TRLIRE_ANUL]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_LIQU] [dbo].[TD_VC_020] NOT NULL,
[NU_RECI] [dbo].[TD_VC_010] NOT NULL,
[FE_ANUL] [dbo].[TD_DT_001] NOT NULL,
[CO_ESTA_DOCU] [dbo].[TD_VC_003] NOT NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRLIRE_AN__CO_US__6B84DD35] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRLIRE_AN__FE_US__6C79016E] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRLIRE_AN__CO_US__6D6D25A7] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRLIRE_AN__FE_US__6E6149E0] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRLIRE_ANUL] ADD CONSTRAINT [PK__TRLIRE_A__A3F7BF99145CD596] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_LIQU], [NU_RECI]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRLIRE_ANUL] ADD CONSTRAINT [FK__TRLIRE_AN__CO_EM__20E2A80C] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
